﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

USE [ARR]
GO

INSERT INTO Months(Date)
VALUES 
('2007/01/01'),
('2007/02/01'),
('2007/03/01'),
('2007/04/01'),
('2007/05/01'),
('2007/06/01'),
('2007/07/01'),
('2007/08/01'),
('2007/09/01'),
('2007/10/01'),
('2007/11/01'),
('2007/12/01'),
('2008/01/01'),
('2008/02/01'),
('2008/03/01'),
('2008/04/01'),
('2008/05/01'),
('2008/06/01'),
('2008/07/01'),
('2008/08/01'),
('2008/09/01'),
('2008/10/01'),
('2008/11/01'),
('2008/12/01'),
('2009/01/01'),
('2009/02/01'),
('2009/03/01'),
('2009/04/01'),
('2009/05/01'),
('2009/06/01'),
('2009/07/01'),
('2009/08/01'),
('2009/09/01'),
('2009/10/01'),
('2009/11/01'),
('2009/12/01'),
('2010/01/01'),
('2010/02/01'),
('2010/03/01'),
('2010/04/01'),
('2010/05/01'),
('2010/06/01'),
('2010/07/01'),
('2010/08/01'),
('2010/09/01'),
('2010/10/01'),
('2010/11/01'),
('2010/12/01'),
('2011/01/01'),
('2011/02/01'),
('2011/03/01'),
('2011/04/01'),
('2011/05/01'),
('2011/06/01'),
('2011/07/01'),
('2011/08/01'),
('2011/09/01'),
('2011/10/01'),
('2011/11/01'),
('2011/12/01'),
('2012/01/01'),
('2012/02/01'),
('2012/03/01'),
('2012/04/01'),
('2012/05/01'),
('2012/06/01'),
('2012/07/01'),
('2012/08/01'),
('2012/09/01'),
('2012/10/01'),
('2012/11/01'),
('2012/12/01'),
('2013/01/01'),
('2013/02/01'),
('2013/03/01'),
('2013/04/01'),
('2013/05/01'),
('2013/06/01'),
('2013/07/01'),
('2013/08/01'),
('2013/09/01'),
('2013/10/01'),
('2013/11/01'),
('2013/12/01'),
('2014/01/01'),
('2014/02/01'),
('2014/03/01'),
('2014/04/01'),
('2014/05/01'),
('2014/06/01'),
('2014/07/01'),
('2014/08/01'),
('2014/09/01'),
('2014/10/01'),
('2014/11/01'),
('2014/12/01'),
('2015/01/01'),
('2015/02/01'),
('2015/03/01'),
('2015/04/01'),
('2015/05/01'),
('2015/06/01'),
('2015/07/01'),
('2015/08/01'),
('2015/09/01'),
('2015/10/01'),
('2015/11/01'),
('2015/12/01'),
('2016/01/01'),
('2016/02/01'),
('2016/03/01'),
('2016/04/01'),
('2016/05/01'),
('2016/06/01'),
('2016/07/01'),
('2016/08/01'),
('2016/09/01'),
('2016/10/01'),
('2016/11/01'),
('2016/12/01'),
('2017/01/01'),
('2017/02/01'),
('2017/03/01'),
('2017/04/01'),
('2017/05/01'),
('2017/06/01'),
('2017/07/01'),
('2017/08/01'),
('2017/09/01'),
('2017/10/01'),
('2017/11/01'),
('2017/12/01'),
('2018/01/01'),
('2018/02/01'),
('2018/03/01'),
('2018/04/01'),
('2018/05/01'),
('2018/06/01'),
('2018/07/01'),
('2018/08/01'),
('2018/09/01'),
('2018/10/01'),
('2018/11/01'),
('2018/12/01'),
('2019/01/01'),
('2019/02/01'),
('2019/03/01'),
('2019/04/01'),
('2019/05/01'),
('2019/06/01'),
('2019/07/01'),
('2019/08/01'),
('2019/09/01'),
('2019/10/01'),
('2019/11/01'),
('2019/12/01'),
('2020/01/01'),
('2020/02/01'),
('2020/03/01'),
('2020/04/01'),
('2020/05/01'),
('2020/06/01'),
('2020/07/01'),
('2020/08/01'),
('2020/09/01'),
('2020/10/01'),
('2020/11/01'),
('2020/12/01')

SET IDENTITY_INSERT [PlanogramLocations] ON
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (1, N'FOOD')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (2, N'Forecourt')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (3, N'Freezer')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (4, N'Gondola')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (5, N'GrabAndGo')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (6, N'NO POG')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (7, N'Other Exhibition')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (8, N'Transaction Area')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (9, N'WIC')
INSERT [PlanogramLocations] ([Id], [Name]) VALUES (10, N'Open Cooler')
SET IDENTITY_INSERT [PlanogramLocations] OFF


SET IDENTITY_INSERT [AttributeTypes] ON
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (1, N'Product Segment', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (2, N'Other Product Segment', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (3, N'Size Segment', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (4, N'Package', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (5, N'Type of Consumption', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (6, N'Flavour', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (7, N'Sugar / Low Calorie', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (8, N'Others', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (9, N'Type2', 0)
INSERT [AttributeTypes] ([Id], [Name], [IsArticleBaseColumn]) VALUES (10, N'Size2', 0)
SET IDENTITY_INSERT [AttributeTypes] OFF

SET IDENTITY_INSERT [CategoryUniverse] ON
INSERT [CategoryUniverse] ([Id], [Universe]) VALUES (1, N'Food')
INSERT [CategoryUniverse] ([Id], [Universe]) VALUES (2, N'Non-Food')
SET IDENTITY_INSERT [CategoryUniverse] OFF

SET IDENTITY_INSERT [CategoryRoles] ON
INSERT [CategoryRoles] ([Id], [Role]) VALUES (1, N'Dominant')
INSERT [CategoryRoles] ([Id], [Role]) VALUES (2, N'Prominent')
INSERT [CategoryRoles] ([Id], [Role]) VALUES (3, N'Convenient')
SET IDENTITY_INSERT [CategoryRoles] OFF

/****** Object:  Table [dbo].[Categories]    Script Date: 02/24/2011 16:23:10 ******/
SET IDENTITY_INSERT [dbo].[Categories] ON
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (1, NULL, N'CARWASH', N'Car wash', 1, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (2, 1, N'259900', N'Car wash', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (3, 2, N'250200', N'VACUUM/AIR/LIQUIDE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (4, 2, N'250300', N'CAR WASH', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (5, 2, N'R25000', N'Car Wash Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (6, NULL, N'CLEANCP', N'Clean CP', 1, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (7, 6, N'020000', N'Cigarettes', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (8, 7, N'020100', N'CIGARETTES PREMIUM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (9, 7, N'020200', N'BRANDED/DISCOUNT CIG', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (10, 7, N'020300', N'SUBGENERIC/PRIVATE L', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (11, 7, N'020400', N'IMPORTS CIGARETTES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (12, 7, N'R02000', N'Cigarette Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (13, 6, N'030000', N'Other Tobacco', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (14, 13, N'030100', N'SMOKELESS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (15, 13, N'030200', N'CIGARS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (16, 13, N'030300', N'PAPERS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (17, 13, N'030400', N'PIPES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (18, 13, N'030500', N'PIPE/CIGAR. TOBACCO', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (19, 13, N'030600', N'OTHER TOBACCO PROD.', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (20, 13, N'R03000', N'Other Tobacco Rebate', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (21, 6, N'040000', N'Beer', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (22, 21, N'040100', N'SUPER PREMIUM BEER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (23, 21, N'040200', N'PREMIUM BEER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (24, 21, N'040300', N'POPULAR BEER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (25, 21, N'040400', N'BUDGET BEER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (26, 21, N'040500', N'IMPORTS BEER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (27, 21, N'040600', N'MICROBREWS / CRAFT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (28, 21, N'040700', N'MALT LIQUOR', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (29, 21, N'040800', N'NON-ALCOHOLIC', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (30, 21, N'040900', N'FLAVOURED MALT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (31, 21, N'049900', N'EMPTY PACKAGE DEPOSI', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (32, 21, N'R04000', N'Beer Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (33, 6, N'050000', N'Wine', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (34, 33, N'050100', N'TABLE /VARIETAL WINE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (35, 33, N'050200', N'CHAMPAGNE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (36, 33, N'050300', N'COOLERS/WINE COCKT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (37, 33, N'050400', N'FORTIFIED WINE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (38, 33, N'R05000', N'Wine Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (39, 6, N'060000', N'Liquor', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (40, 39, N'060100', N'DISTILLED SPIRITS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (41, 39, N'060200', N'PREPARED COCKTAILS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (42, 39, N'060300', N'BRANDY / COGNAC', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (43, 39, N'R06000', N'Liquor Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (44, 6, N'070000', N'Packaged Beverages', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (45, 44, N'070100', N'CARB. SOFTDRINKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (46, 44, N'070200', N'ICED TEA', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (47, 44, N'070300', N'SPORTS DRINKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (48, 44, N'070400', N'JUICE DRINKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (49, 44, N'070500', N'BOTTLED WATER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (50, 44, N'070600', N'OTH PACK BEVERAGES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (51, 44, N'070700', N'ALTERNATIVE Beverages', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (52, 44, N'079900', N'EMPTY PACKAGE DEPOSI', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (53, 44, N'R07000', N'Packaged Bev (non-ca', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (54, 44, N'R07001', N'Packaged Bev (soda)', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (55, 6, N'080000', N'Candy', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (56, 55, N'080100', N'GUM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (57, 55, N'080200', N'CANDY ROLLS/MINTS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (58, 55, N'080300', N'CHOCO BARS/ PACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (59, 55, N'080400', N'NON-CHOC. BARS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (60, 55, N'080500', N'BAGGED PEG CANDY', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (61, 55, N'080600', N'NOVELTIES/SEASONAL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (62, 55, N'080700', N'PENNY COUNTER GOODS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (63, 55, N'080800', N'BULK CANDY', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (64, 55, N'R08000', N'Candy Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (65, 6, N'090000', N'Fluid Milk Products', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (66, 65, N'090100', N'WHOLE MILK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (67, 65, N'090200', N'2% MILK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (68, 65, N'090300', N'1% MILK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (69, 65, N'090400', N'SKIM/NON FAT MILK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (70, 65, N'090500', N'FLAVORED  MILK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (71, 65, N'090600', N'CREAM / CREAMER', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (72, 65, N'090700', N'READYTODRINK MILK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (73, 65, N'099900', N'EMPTY PACKAGE DEPOSI', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (74, 65, N'R09000', N'Fluid Milk Product R', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (75, 6, N'100000', N'Other Dairy', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (76, 75, N'100100', N'PACKAGED CHEESE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (77, 75, N'100200', N'EGGS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (78, 75, N'100300', N'BUTTER/MARGARINE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (79, 75, N'100400', N'COTTAGE/CREAM CHEESE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (80, 75, N'100500', N'YOGURT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (81, 75, N'100600', N'OTHER DAIRY', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (82, 75, N'100700', N'PACKAGED LUNCHEON ME', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (83, 75, N'100800', N'OTHER PACKAGED MEATS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (84, 75, N'100900', N'LUNCH PACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (85, 75, N'R10000', N'Other Dairy & Deli R', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (86, 6, N'110000', N'Commissary & Other Pack', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (87, 86, N'110100', N'PACKAGED SANDWICHES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (88, 86, N'110500', N'OTH PACK DELI PRODU', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (89, 86, N'110600', N'THAW HEAT&EAT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (90, 86, N'110700', N'MEALS READY TO EAT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (91, 86, N'R11000', N'Commissary & Other P', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (92, 6, N'120000', N'Packaged Ice Cream/Novelties', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (93, 92, N'120100', N'PREMIUM ICE CREAM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (94, 92, N'120200', N'ICE CREAM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (95, 92, N'120300', N'FROZEN YOG./SORBET', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (96, 92, N'120400', N'FROZEN NOVELTIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (97, 92, N'R12000', N'Ice Cream/Novelties', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (98, 6, N'130000', N'Frozen Foods', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (99, 98, N'130100', N'FROZ. DINNERS/ENTREE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (100, 98, N'130200', N'FROZEN PIZZA', 3, N'NACS')
GO
print 'Processed 100 total records'
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (101, 98, N'130300', N'OTHER FROZEN FOODS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (102, 98, N'R13000', N'Frozen Food Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (103, 6, N'140000', N'Packaged bread', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (104, 103, N'140100', N'PACKAGED BREAD', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (105, 103, N'R14000', N'Packaged Bread Rebat', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (106, 6, N'150000', N'Salty Snacks', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (107, 106, N'150100', N'POTATO CHIPS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (108, 106, N'150200', N'TORTILLA/CORN CHIPS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (109, 106, N'150300', N'PRETZELS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (110, 106, N'150400', N'NUTS / SEEDS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (111, 106, N'150500', N'RTE POPCORN', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (112, 106, N'150600', N'CRACKERS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (113, 106, N'150700', N'OTHER SALTY SNACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (114, 106, N'R15000', N'Salty Snack Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (115, 6, N'160000', N'Packaged Sweet Snacks', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (116, 115, N'160100', N'SNACK/CAKES/PASTRIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (117, 115, N'160200', N'MUFFINS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (118, 115, N'160300', N'COOKIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (119, 115, N'R16000', N'Packaged Sweet Snack', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (120, 6, N'170000', N'Alternative Snacks', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (121, 120, N'170100', N'MEAT SNACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (122, 120, N'170200', N'GRANOLA/FRUIT SNACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (123, 120, N'170300', N'ENERGY BARS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (124, 120, N'170400', N'OTH.ALTERN. SNACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (125, 120, N'R17000', N'Alternative Snacks R', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (126, 6, N'180000', N'Perishable Grocery', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (127, 126, N'180100', N'FRUITS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (128, 126, N'180200', N'VEGETABLES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (129, 126, N'180300', N'SERVICE DELI MEALS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (130, 126, N'180400', N'SERVICE DELI CHEESE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (131, 126, N'180500', N'SERVICE DELI SALADS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (132, 126, N'180600', N'OTHERSERV. DELI', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (133, 126, N'R18000', N'Perishable Grocery R', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (134, 6, N'190000', N'Edible Grocery', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (135, 134, N'190100', N'PACKAGED COFFEE/TEA', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (136, 134, N'190200', N'BREAKFAST CEREAL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (137, 134, N'190300', N'CONDIMENTS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (138, 134, N'190400', N'OTH EDIBLE GROCERY', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (139, 134, N'R19000', N'Edible Grocery Rebat', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (140, 6, N'200000', N'Non-Edible Grocery', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (141, 140, N'200100', N'LAUNDRY CARE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (142, 140, N'200200', N'DISH CARE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (143, 140, N'200300', N'HOUSEHOLD CARE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (144, 140, N'200400', N'PAPER/PLASTIC/FOIL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (145, 140, N'200500', N'PET CARE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (146, 140, N'200600', N'OTH NON-EDIBLE GROCE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (147, 140, N'R20000', N'Non-Edible Grocery R', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (148, 6, N'210000', N'Health and Beauty Care', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (149, 148, N'210100', N'ANALGESICS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (150, 148, N'210200', N'COUGH +COLD REMEDIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (151, 148, N'210300', N'STOMACH REMEDIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (152, 148, N'210400', N'VITAMINS/ SUPPLEMENT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (153, 148, N'210500', N'OTHER INTERNAL OTC', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (154, 148, N'210600', N'GROOMING AIDS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (155, 148, N'210700', N'FEMININE HYGIENE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (156, 148, N'210800', N'FAMILY PLANNING', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (157, 148, N'210900', N'BABY CARE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (158, 148, N'211000', N'SKIN CARE / LOTIONS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (159, 148, N'211100', N'COSMETICS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (160, 148, N'211200', N'OTHER HBC', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (303, 148, N'211300', N'Liquid Vitamins, Supplements & Energy Shots', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (161, 148, N'R21000', N'Health & Beauty Care', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (162, 6, N'220000', N'General Merchandise', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (163, 162, N'220100', N'PREPAID TELECOMM.', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (164, 162, N'220200', N'BATTERIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (165, 162, N'220300', N'FILM / PHOTO', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (166, 162, N'220400', N'SCOOL/OFFICE SUPPLIE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (167, 162, N'220500', N'GREETING/GIFT/TOYS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (168, 162, N'220600', N'TRADING CARDS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (169, 162, N'220700', N'WEARABLES / APPAREL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (170, 162, N'220800', N'SMOKING ACCESSOIRES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (171, 162, N'220900', N'VIDEO / AUDIO / TAPE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (172, 162, N'221000', N'HOUSEWARES/TOOLS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (173, 162, N'221100', N'FLORAL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (174, 162, N'221200', N'SEASONAL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (175, 162, N'221300', N'OTHER GM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (176, 162, N'221400', N'TELECOMMUNICATIONS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (300, 162, N'221500', N'Propane Exchanges', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (177, 162, N'R22000', N'General Merchandise', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (178, 6, N'230000', N'Publications', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (179, 178, N'230100', N'NEWSPAPERS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (180, 178, N'230200', N'MAGAZINES/TABLOIDS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (181, 178, N'230300', N'ADULT MAGAZINES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (182, 178, N'230400', N'PAPERBOOKS/BOOKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (183, 178, N'230500', N'COMICS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (184, 178, N'230600', N'TRADERS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (185, 178, N'230700', N'MAPS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (186, 178, N'230800', N'OTHER PUBLICATIONS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (187, 178, N'R23000', N'Publication Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (188, 6, N'240000', N'Automotive Products', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (189, 188, N'240100', N'MOTOR OIL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (190, 188, N'240200', N'ANTIFREEZE ETC.', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (191, 188, N'240300', N'BRAKE FLUIDS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (192, 188, N'240400', N'CAR CARE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (193, 188, N'240500', N'OTHER ADDITIVES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (194, 188, N'R24000', N'Automotive Product R', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (195, 6, N'280000', N'Ice', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (196, 195, N'280100', N'BAGGED/BLOCKED ICE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (197, 195, N'R28000', N'Ice Rebates', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (198, 6, N'290000', N'Foodservice Prepared On-Site', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (199, 198, N'290100', N'CHICKEN', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (200, 198, N'290200', N'MEXICAN', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (201, 198, N'290300', N'PIZZA', 3, N'NACS')
GO
print 'Processed 200 total records'
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (202, 198, N'290400', N'SEAFOOD', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (203, 198, N'290500', N'HOT DOGS/GRILL PROD.', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (204, 198, N'290600', N'HAMBURGERS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (205, 198, N'290700', N'SANDWICHES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (206, 198, N'290800', N'FROZEN TREATS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (207, 198, N'290900', N'BAKERY', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (208, 198, N'291000', N'SOUP & SALAD', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (209, 198, N'291100', N'OTHER CUISINE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (210, 198, N'299600', N'FRENCH FRIES/ WEDGES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (211, 198, N'299700', N'MEAT PIES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (212, 198, N'299800', N'NACHOS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (213, 198, N'299900', N'COMBOS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (214, 198, N'R29000', N'Foodservice Prepared', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (215, 6, N'300000', N'Hot Dispensed Beverages', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (216, 215, N'300100', N'COFFEE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (217, 215, N'300200', N'HOT TEA', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (218, 215, N'300300', N'HOT CHOCOLATE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (219, 215, N'300400', N'CAPPUCC./SPEC.COFFEE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (220, 215, N'300500', N'REFILLS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (221, 215, N'300600', N'COFFEE CLUB MUGS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (222, 215, N'300700', N'OTHER HOT BEVERAGES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (223, 215, N'R30000', N'Hot Dispensed Bevera', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (224, 6, N'310000', N'Cold dispensed Beverages', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (225, 224, N'310100', N'FOUNTAIN-CARBONATED', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (226, 224, N'310200', N'FOUNTAIN-NON-CARBON.', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (227, 224, N'310300', N'FOUNTAIN SPORT DRINK', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (228, 224, N'310400', N'REFILLS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (229, 224, N'310500', N'FOUNTAIN CLUB MUGS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (230, 224, N'310600', N'OTH COLD BEVERAGES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (231, 224, N'R31000', N'Cold Dispensed Bever', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (232, 6, N'320000', N'Frozen Dispensed Beverages', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (233, 232, N'320100', N'FRO.CARB.BEVERAGES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (234, 232, N'320200', N'FROZEN NON-CARBONATE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (235, 232, N'R32000', N'Frozen Dispensed Bev', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (236, 6, N'900000', N'Served Alcoholic Beverages', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (237, 236, N'900100', N'Beer (Served)', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (238, 236, N'900200', N'Wine (Served)', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (239, 236, N'900300', N'Liquor (Served)', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (240, 236, N'900400', N'OTHER ALC. BEVERAGES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (241, 236, N'R90000', N'Served Alcoholic Bev', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (242, NULL, N'FUELS', N'Fuels', 1, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (243, 242, N'010000', N'Fuel Products', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (244, 243, N'010100', N'UNLEADED-REGULAR', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (245, 243, N'010200', N'UNLEADED-MID', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (246, 243, N'010300', N'UNLEADED-PREMIUM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (247, 243, N'010400', N'DIESEL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (248, 243, N'010500', N'PROPANE FUEL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (249, 243, N'010600', N'KEROSENE FUEL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (250, 243, N'010700', N'OTHER FUEL PRODUCT', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (251, NULL, N'OTHERSERVICES', N'Other services', 1, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (252, 251, N'250000', N'Automotive Services', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (253, 252, N'250100', N'LUBE / OIL CHANGE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (254, 252, N'250400', N'AUTO REPAIR', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (255, 252, N'250500', N'INSPECTION SERVICES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (256, 252, N'250600', N'AUTO. SERVICE /PARTS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (257, 251, N'260000', N'Store Services', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (258, 257, N'260100', N'PAY PHONES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (259, 257, N'260200', N'VIDEO RENTAL', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (260, 257, N'260300', N'MONEY ORDERS/GRAMS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (261, 257, N'260400', N'CHECK CASHING', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (262, 257, N'260500', N'ATM', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (263, 257, N'260600', N'COPY/FAX', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (264, 257, N'260700', N'POSTAL / UPS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (265, 257, N'260800', N'VENDING', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (266, 257, N'260900', N'TICKETS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (267, 257, N'261000', N'HOME DELIVERY', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (268, 257, N'261100', N'AMUSEMENTS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (269, 257, N'261200', N'LICENSES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (270, 257, N'261300', N'OTHER STORE SERVICES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (271, 257, N'269000', N'NON SCANNED SALES', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (272, 257, N'269100', N'FUEL PROMOTIONS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (273, 257, N'269200', N'FRANCHISING', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (274, 257, N'R26000', N'Store Services Rebat', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (275, 251, N'270000', N'Lottery', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (276, 275, N'270100', N'LOTTO', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (277, 275, N'270200', N'SCRATCH TICKETS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (278, 275, N'270300', N'VIDEO GAMING REVENUE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (279, 275, N'270400', N'SLOT MACHINE REVENUE', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (280, 275, N'270500', N'NATIONAL CAMPAIGN', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (281, 275, N'R27000', N'Lottery/Gaming Rebat', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (282, 251, N'980000', N'Service Charges', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (283, 282, N'980100', N'SERVICE CHARGES (SUR', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (284, 282, N'989400', N'No Sal.Rev.Money O.F', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (285, 282, N'989500', N'No Sal.Rev.Prepaid C', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (286, 282, N'989600', N'No Sal.Rev.Scr.Tic.F', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (287, 282, N'989700', N'No Sal.Rev.LOTTO F.V', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (288, 282, N'989800', N'No Sal.Rev.Ch.Cash.F', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (289, 282, N'989900', N'No Sales Rev.-Other', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (290, 251, N'990000', N'Store Use / Supply', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (291, 290, N'990100', N'EXPENSED ITEMS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (292, 6, N'330000', N'Prepaid Cards', 2, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (301, 292, N'330100', N'Pre-paid Telecomm.', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (302, 292, N'330200', N'Other Pre-paid Cards', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (293, 86, N'110400', N'LUNCH PACKS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (294, 162, N'221991', N'UKIE other medium', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (295, 162, N'221990', N'UKIE other zero', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (296, 162, N'221992', N'UKIE other maximum', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (297, 86, N'110300', N'OTHER PACK MEATS', 3, N'NACS')
INSERT [dbo].[Categories] ([Id], [ParentId], [Code], [Name], [Level], [Convention]) VALUES (299, 215, N'299901', N'COMBOS', 3, N'NACS')
SET IDENTITY_INSERT [dbo].[Categories] OFF

SET IDENTITY_INSERT [dbo].[Attributes] ON
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (1, 1, 188, N'Monograde', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (2, 1, 188, N'Multigrade', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (3, 1, 7, N'Small (5 Cigarettes)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (4, 1, 7, N'Medium (1 Cigarettes)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (5, 1, 7, N'Large (2 Cigarettes)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (6, 1, 224, N'Iced Coffee', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (7, 1, 198, N'Hot Dog', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (8, 1, 198, N'Hot Dog Americano', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (9, 1, 198, N'Hot Dog Mexicano', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (10, 1, 198, N'Hot Dog Ranchero', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (11, 1, 198, N'Hot Dog Tradicional', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (12, 1, 198, N'Breakfast', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (13, 1, 198, N'Chicken', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (14, 1, 198, N'Club', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (15, 1, 198, N'Ham & Cheese', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (16, 1, 198, N'Meat', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (17, 1, 198, N'Siciliano', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (18, 1, 198, N'Turkey', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (19, 1, 198, N'Hamburger', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (20, 1, 198, N'Omelette', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (21, 1, 198, N'Ham', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (22, 1, 198, N'Turkey ', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (23, 1, 232, N'Frappe', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (24, 1, 232, N'Smoothie', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (25, 1, 215, N'Almendra', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (26, 1, 215, N'Amaretto', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (27, 1, 215, N'Coffee', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (28, 1, 215, N'Capuccino', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (29, 1, 215, N'Caramel', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (30, 1, 215, N'Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (31, 1, 215, N'Coffee Mugs', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (32, 1, 215, N'Coffee w/ milk', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (33, 1, 215, N'COM', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (34, 1, 215, N'Expresso', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (35, 1, 215, N'Irish Coffee', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (36, 1, 215, N'Macciato', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (37, 1, 215, N'Mocaccino', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (38, 1, 215, N'Tea', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (39, 1, 215, N'Tea w/Milk', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (40, 1, 215, N'Tinto', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (41, 1, 215, N'Tumug', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (42, 1, 215, N'Vainilla', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (43, 1, 39, N'Aguardiente', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (44, 1, 39, N'Liquor', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (45, 1, 39, N'Whisky', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (46, 1, 39, N'Rum', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (47, 1, 39, N'Tequila', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (48, 1, 39, N'Vodka', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (49, 1, 39, N'Cocktail', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (50, 1, 44, N'Non Cola', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (51, 1, 44, N'Flavored Water', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (52, 1, 44, N'Traditional Water', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (53, 1, 44, N'Cola', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (54, 1, 44, N'Other Juices', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (55, 1, 292, N'Mobil Phone', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (56, 1, 292, N'Phone', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (57, 1, 292, N'Internet', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (58, 3, 21, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (59, 3, 21, N'Multipack', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (60, 3, 55, N'< 5 grs.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (61, 3, 55, N'> = 5 grs./< 1 grs.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (62, 3, 55, N'> = 1 grs.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (63, 3, 55, N'Small (<1 grs)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (64, 3, 7, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (65, 3, 7, N'Multi-Pack', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (66, 3, 224, N'Combo', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (67, 3, 224, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (68, 3, 65, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (69, 3, 65, N'Family', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (70, 3, 198, N'Hot Sandwich', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (71, 3, 198, N'Cold Sandwich', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (72, 3, 215, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (73, 3, 215, N'Combo', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (74, 3, 75, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (75, 3, 44, N'Immediate Consumption', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (76, 3, 44, N'Future Consumption', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (77, 3, 103, N'Small (<=3 gr.)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (78, 3, 103, N'Medium (>3<5 gr.)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (79, 3, 103, N'Large (>=5 gr.)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (80, 3, 92, N'Impulsive', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (81, 3, 115, N'Small (<1 grs)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (82, 3, 115, N'Big (>/= 1 grs.)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (83, 3, 106, N'Small (< 1 grs.)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (84, 3, 106, N'Big (>/= 1 grs.)', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (85, 2, 198, N'Double', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (86, 2, 198, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (87, 2, 162, N'Batteries', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (88, 2, 162, N'E-Zone', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (89, 2, 162, N'Housewares/Tools', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (90, 2, 162, N'Smoking Accessoires', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (91, 2, 292, N'1', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (92, 2, 292, N'2', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (93, 2, 292, N'3', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (94, 2, 292, N'5', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (95, 2, 292, N'15', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (96, 2, 106, N'Natural', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (97, 2, 106, N'Mixed', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (98, 2, 106, N'Chicken', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (99, 2, 106, N'Lemon', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (100, 2, 106, N'Mayonnaise', NULL, NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (101, 4, 21, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (102, 4, 21, N'Multipack', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (103, 4, 198, N'Extra', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (104, 4, 198, N'Sandwich', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (105, 4, 178, N'Adult', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (106, 5, 55, N'Other Chocolate Bars', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (107, 5, 55, N'Gum', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (108, 5, 55, N'Lolly Pop', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (109, 5, 55, N'Boxed Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (110, 5, 55, N'Other Novelties', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (111, 5, 55, N'Chocolate Candies', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (112, 5, 55, N'Candies', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (113, 5, 55, N'Candy Chews', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (114, 5, 55, N'Candy Rolls', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (115, 5, 55, N'Block Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (116, 5, 55, N'Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (117, 5, 55, N'Candy Drops', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (118, 5, 7, N'Extra Light', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (119, 5, 7, N'Light', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (120, 5, 7, N'Full Flavor', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (121, 5, 7, N'Menthol', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (122, 5, 224, N'CSD', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (123, 5, 224, N'Tea', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (124, 5, 224, N'Non Cola', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (125, 5, 224, N'Other Type of Consumption', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (126, 5, 224, N'Iced Coffee', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (127, 5, 198, N'Hot Dogs/Grill Prod.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (128, 5, 198, N'Sandwiches/Wraps', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (129, 5, 198, N'Hamburgers', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (130, 5, 232, N'Frappe', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (131, 5, 232, N'Smoothie', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (132, 5, 215, N'Gourmet Coffee', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (133, 5, 215, N'American Coffee', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (134, 5, 215, N'Other Type', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (135, 5, 215, N'Hot Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (136, 5, 215, N'COM', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (137, 5, 215, N'Hot Tea', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (138, 5, 44, N'Still', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (139, 5, 44, N'Sparkling', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (140, 5, 44, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (141, 5, 44, N'Multi-Pack', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (142, 5, 178, N'General Interest', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (143, 5, 178, N'Architecture/Design/Deco', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (144, 5, 178, N'Cars', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (145, 5, 178, N'Entertainment', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (146, 5, 178, N'Women', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (147, 5, 178, N'Sports', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (148, 5, 178, N'Business', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (149, 5, 178, N'Adult', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (150, 5, 178, N'Children', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (151, 5, 178, N'Young/Teen', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (152, 5, 178, N'Turism', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (153, 5, 33, N'Red', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (154, 5, 33, N'White', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (155, 5, 33, N'Rose', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (156, 6, 7, N'Extra Light', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (157, 6, 7, N'Light', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (158, 6, 7, N'Full Flavor', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (159, 6, 7, N'Menthol', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (160, 6, 44, N'Lemon Lime', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (161, 6, 44, N'Soda', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (162, 6, 44, N'Cola Regular', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (163, 6, 44, N'Low Calorie', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (164, 6, 44, N'Colombiana', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (165, 6, 44, N'Apple', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (166, 6, 44, N'Ginger', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (167, 6, 44, N'Tonic', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (168, 6, 44, N'Grape', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (169, 6, 44, N'Orange', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (170, 6, 44, N'Toronja', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (171, 7, 55, N'Sugar', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (172, 7, 55, N'Sugar Free', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (173, 7, 65, N'Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (174, 7, 65, N'Strawberry', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (175, 7, 65, N'Vainila', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (176, 7, 75, N'Blackberry', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (177, 7, 75, N'Guanabana', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (178, 7, 75, N'Kiwi', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (179, 7, 75, N'Melocoton', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (180, 7, 75, N'Red Fruits', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (181, 7, 75, N'Strawberry', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (182, 7, 75, N'Chocolate', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (183, 7, 75, N'Zucaritas', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (184, 7, 44, N'Sugar', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (185, 7, 44, N'Low Calorie', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (186, 7, 44, N'Apple', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (187, 7, 44, N'Lemon', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (188, 7, 44, N'Mandarin', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (189, 7, 44, N'Light', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (190, 7, 44, N'Mora', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (191, 7, 44, N'Toronja', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (192, 7, 44, N'Lemon Lime', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (193, 7, 44, N'Maracuya', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (194, 7, 106, N'Pop Corn', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (195, 7, 106, N'chicharrón', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (196, 7, 106, N'Other Salty Snacks', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (197, 7, 106, N'Cheese', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (198, 7, 106, N'Platanitos', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (199, 7, 106, N'Snacks Mix', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (200, 8, 44, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (201, 8, 44, N'Family', NULL, NULL)
GO
print 'Processed 200 total records'
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (202, 9, 148, N'Medicines', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (203, 9, 148, N'Grooming Aids', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (204, 9, 148, N'Skin Care/Lotions', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (205, 9, 148, N'Feminine Hygiene', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (206, 9, 148, N'Family Planning', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (207, 9, 44, N'Single', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (208, 10, 21, N'33 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (209, 10, 21, N'Pack x 6', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (210, 10, 21, N'Pack x 12', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (211, 10, 21, N'5 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (212, 10, 21, N'355 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (213, 10, 21, N'946 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (214, 10, 21, N'3 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (215, 10, 21, N'71 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (216, 10, 21, N'35 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (217, 10, 21, N'65 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (218, 10, 21, N'325 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (219, 10, 21, N'1.5 Lts.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (220, 10, 21, N'25 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (221, 10, 44, N'3 ml', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (222, 10, 44, N'5 ml', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (223, 10, 44, N'6 ml', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (224, 10, 44, N'2,5 Lts.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (225, 10, 44, N'6 ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (226, 10, 44, N'5 Lts.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (227, 10, 44, N'25 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (228, 10, 44, N'5 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (229, 10, 44, N'33 ml', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (230, 10, 44, N'1 Lt. - 2.2 Lt.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (231, 10, 44, N'1,5 Lts.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (232, 10, 44, N'237 ml. - 3 ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (233, 10, 44, N'591 ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (234, 10, 44, N'28 ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (235, 10, 44, N'33 Ml.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (236, 10, 44, N'25 ml. Pack x 4', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (237, 10, 44, N'1,365 Lts.', NULL, NULL)
INSERT [dbo].[Attributes] ([Id], [AttributeTypeId], [CategoryId], [AttributeValue], [MinValue], [MaxValue]) VALUES (238, 10, 44, N'473 ml.', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Attributes] OFF

SET IDENTITY_INSERT [dbo].[Countries] ON
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (1, N'AR', N'Argentina', N'Argentine Peso', N'ARS', 0.2100, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0) 
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (2, N'CL', N'Chile', N'Chilean Peso', N'CLP', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (3, N'GT', N'Guatemala', N'Guatemala Qetzal', N'GTQ', 0.1200, 1, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (4, N'CO', N'Colombia', N'Colombian Peso', N'COP', 0.1600, 0, 'NACS', 1, 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 1, 1, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (5, N'SV', N'El Salvador', N'US Dollar', N'USD', 0.1300, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (6, N'HN', N'Honduras', N'Honduras Lempira', N'HNL', 0.1200, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (7, N'NI', N'Nicaragua', N'Nicargaua Córdoba', N'NIO', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (8, N'PA', N'Panamá', N'Panamá Balboa', N'PAB', 0.0700, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (9, N'EC', N'Ecuador', N'Ecuador Sucre', N'ECS', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (11, N'UK', N'UK', N'Pound', N'GBP', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (12, N'NL', N'Netherlands', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (13, N'IT', N'Italy', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (15, N'BE', N'Belgium', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (16, N'LU', N'Luxembourg', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (17, N'IE', N'Ireland', N'Pound', N'GBP', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (18, N'US', N'US', N'US Dollar', N'US$', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (19, N'DE', N'Germany', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (20, N'NO', N'Norway', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (21, N'FR', N'France', N'Euro', N'EUR', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (22, N'CA', N'Canada', N'Canada Dollars', N'CAD', NULL, 0, 'NACS', 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0)
INSERT [dbo].[Countries] ([Id], [Code], [Name], [CurrencyName], [CurrencyISOCode], [TaxRate], [IsVATIncluded], [Convention], [IsVATGeneral], [ArticlesImporter], [StoresImporter], [SalesImporter], [InventoryImporter], [PIDifferencesImporter], [SpacesImporter], [IsArticleMasterSeparateFile], [IsStoreMasterSeparateFile], [DailySales]) VALUES (23, N'DO', N'Republica Dominicana', N'Peso Dominicano', N'DOP', 0.1600, 0, 'NACS', 1, 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 'Standard Excel Importer', 0, 0, 1)
SET IDENTITY_INSERT [dbo].[Countries] OFF

SET IDENTITY_INSERT [Currencies] ON
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (1, 1, N'Argentine Peso', N'ARS')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (2, 2, N'Chilean Peso', N'CLP')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (3, 3, N'Guatemala Qetzal', N'GTQ')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (4, 4, N'Colombian Peso', N'COP')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (5, 5, N'US Dollar', N'USD')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (6, 6, N'Honduras Lempira', N'HNL')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (7, 7, N'Nicargaua Córdoba', N'NIO')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (8, 8, N'Panamá Balboa', N'PAB')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (9, 9, N'Ecuador Sucre', N'ECS')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (10, 11, N'Pound', N'GBP')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (11, 12, N'Euro', N'EUR')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (12, 13, N'Euro', N'EUR')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (13, 15, N'Euro', N'EUR')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (14, 16, N'Euro', N'EUR')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (15, 17, N'Pound', N'GBP')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (16, 18, N'US Dollar', N'US$')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (17, 19, N'Euro', N'EUR')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (18, 20, N'Corona Noruega', N'NOK')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (19, 21, N'Euro', N'EUR')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (20, 22, N'Canada Dollars', N'CAD')
INSERT [Currencies] ([Id], [CountryId], [CurrencyName], [CurrencyISOCode]) VALUES (21, 23, N'Peso Dominicano', N'DOP')
SET IDENTITY_INSERT [Currencies] OFF

--SET IDENTITY_INSERT [dbo].[StoreGroups] ON
--INSERT [dbo].[StoreGroups] ([Id], [Name]) VALUES (1, N'Lira y Prados')
--SET IDENTITY_INSERT [dbo].[StoreGroups] OFF

--SET IDENTITY_INSERT [dbo].[Stores] ON
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (1, 23, N'00001', N'La Lira', N'', N'Santo Domingo', NULL, NULL, NULL, 'On the Run')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (2, 23, N'00002', N'Los Prados', N'', N'Santo Domingo', NULL, NULL, NULL, 'On the Run')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (3, 23, N'00004', N'Jose Contreras/Universitario', N'', N'Santo Domingo', NULL, NULL, NULL, 'On the Run')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (4, 23, N'00005', N'Ave. Venezuela', N'', N'Santo Domingo', NULL, NULL, NULL, 'On the Run')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (5, 23, N'00007', N'La Vega', N'', N'Santo Domingo', NULL, NULL, NULL, 'Retrofit')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (6, 23, N'00009', N'Arroyo Hondo', N'', N'Santo Domingo', NULL, NULL, NULL, 'Retrofit')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (7, 23, N'00011', N'El Portal', N'', N'Santo Domingo', NULL, NULL, NULL, 'On the Run')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (8, 1, N'6222', N'Libertador', N'Capital Federal', N'Capital Federal', NULL, NULL, NULL, 'Tigermarket')
--INSERT [dbo].[Stores] ([Id], [CountryId], [Code], [Name], [Region], [City], [Address], [Phone], [Fax], [Format]) VALUES (9, 1, N'6275', N'El Club', N'GBA', N'Vicente López', NULL, NULL, NULL, 'Esso Shop')
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (56, 4, N'6601', N'CO TIGERMARKET CHILE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (57, 4, N'6602', N'CO ON THE RUN JR ILARCO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (58, 4, N'6603', N'CO SERVICE STATION INCOCENTRO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (59, 4, N'6604', N'CO TIGERMARKET LAS MARGARITAS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (60, 4, N'6605', N'CO TIGERMARKET PUENTE ARANDA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (61, 4, N'6606', N'CO SERVICE STATION QUIROGA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (62, 4, N'6607', N'CO TIGER EXPRESS SANTA BARBARA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (63, 4, N'6609', N'CO MOBIL MART LA TEXANA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (64, 4, N'6611', N'CO TIGERMARKET EL TRIÁNGULO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (65, 4, N'6612', N'CO SERVICE STATION LAS VEGAS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (66, 4, N'6613', N'CO SERVICE STATION MUZÚ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (67, 4, N'6614', N'CO SERVICE STATION EL PRADO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (68, 4, N'6615', N'CO SERVICE STATION BOSTON', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (69, 4, N'6616', N'CO TIGERMARKET CHIPICHAPE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (70, 4, N'6617', N'CO SERVICE STATION EL PORTÓN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (71, 4, N'6618', N'CO SERVICE STATION MOBIL LA 70', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (72, 4, N'6619', N'CO ON THE RUN JR PANCE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (73, 4, N'6620', N'CO SERVICE STATION PASOANCHO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (74, 4, N'6621', N'CO TIGERMARKET PLAZA AUTOPISTA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (75, 4, N'6622', N'CO SERVICE STATION SIMÓN BOLÍV', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (76, 4, N'6624', N'CO TIGERMARKET BELLO ESSO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (77, 4, N'6625', N'CO SERVICE STATION CASTILLA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (78, 4, N'6627', N'CO SERVICE STATION MOBIL BELLO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (79, 4, N'6628', N'CO TIGERMARKET NORUEGA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (80, 4, N'6629', N'CO SERVICE STATION ORIENTAL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (81, 4, N'6631', N'CO SERVICE STATION PORTAL DEL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (82, 4, N'6632', N'CO TIGER EXPRESS ESSO LAS VEGA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (83, 4, N'6633', N'CO SERVICE STATION AUTOBOYACÁ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (84, 4, N'6635', N'CO SERVICE STATION LA AMERICAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (85, 4, N'6636', N'CO SERVICE STATION SIBERIA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (86, 4, N'6637', N'CO ON THE RUN JR AUTOPISTA MED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (87, 4, N'6638', N'CO SERVICE STATION HEROES', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (88, 4, N'6639', N'CO SERVICE STATION INDUSTRIALE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (89, 4, N'6640', N'CO: Service Station Avenida 68', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (90, 4, N'6642', N'CO: Service Station Comuneros', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (91, 4, N'6643', N'CO: Service Station Española', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (92, 4, N'6644', N'CO: Service Station Ciudad Sal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (93, 4, N'6645', N'CO: Service Station Brasil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (94, 4, N'6646', N'CO Service Station Ermita Capi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (95, 4, N'6647', N'CO: Service Station Mayorca', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (96, 4, N'6648', N'CO Service Station Cruce Mosqu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (97, 4, N'6649', N'CO Service Station Andes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (98, 4, N'6650', N'CO Service Station Kennedy', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (99, 4, N'6651', N'CO Libertadores', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (100, 4, N'6652', N'CO Bolivariana', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--INSERT [Stores] ([Id], [CountryId], [Code], [Name], [Region], [Subregion], [City], [State], [SEL], [ShoppingOccasion], [Size], [Address], [Phone], [Fax], [Format], [PBL], [Mail], [Contact], [SiteLocation], [ShopType], [Layout], [OpeningHours], [Attribute1], [Attribute2]) VALUES (101, 4, N'6653', N'CO Panorama', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
--SET IDENTITY_INSERT [dbo].[Stores] OFF

SET IDENTITY_INSERT [dbo].[CurrencyExchangeRates] ON
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (1, 23, CAST(0xC4320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (2, 23, CAST(0xE3320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (3, 23, CAST(0x01330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (4, 23, CAST(0x20330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (5, 23, CAST(0x3F330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (6, 23, CAST(0x5D330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (7, 23, CAST(0x7C330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (8, 23, CAST(0x9A330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (9, 23, CAST(0xB9330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (10, 23, CAST(0xD8330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (11, 23, CAST(0xF4330B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (12, 23, CAST(0x13340B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (13, 23, CAST(0x57310B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (14, 23, CAST(0x76310B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (15, 23, CAST(0x94310B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (16, 23, CAST(0xB3310B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (17, 23, CAST(0xD2310B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (18, 23, CAST(0xF0310B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (19, 23, CAST(0x0F320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (20, 23, CAST(0x2D320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (21, 23, CAST(0x4C320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (22, 23, CAST(0x6B320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (23, 23, CAST(0x87320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (24, 23, CAST(0xA6320B00 AS Date), 0.0273, 21, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (25, 4, CAST(0xC4320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (26, 4, CAST(0xE3320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (27, 4, CAST(0x01330B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (28, 4, CAST(0x20330B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (29, 4, CAST(0x3F330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (30, 4, CAST(0x5D330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (31, 4, CAST(0x7C330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (32, 4, CAST(0x9A330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (33, 4, CAST(0xB9330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (34, 4, CAST(0xD8330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (35, 4, CAST(0xF4330B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (36, 4, CAST(0x13340B00 AS Date), 0.0056, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (37, 4, CAST(0x57310B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (38, 4, CAST(0x76310B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (39, 4, CAST(0x94310B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (40, 4, CAST(0xB3310B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (41, 4, CAST(0xD2310B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (42, 4, CAST(0xF0310B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (43, 4, CAST(0x0F320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (44, 4, CAST(0x2D320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (45, 4, CAST(0x4C320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (46, 4, CAST(0x6B320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (47, 4, CAST(0x87320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (48, 4, CAST(0xA6320B00 AS Date), 0.0273, 4, 5, NULL)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (49, 4, CAST(0x50340B00 AS Date), 0.0056, 4, 5, 0.0000)
INSERT [CurrencyExchangeRates] ([Id], [CountryId], [Date], [Rate], [SourceCurrencyId], [TargetCurrencyId], [ForexRate]) VALUES (50, 4, CAST(0x31340B00 AS Date), 0.0056, 4, 5, 0.0000)
SET IDENTITY_INSERT [dbo].[CurrencyExchangeRates] OFF

--INSERT [dbo].[StoreGroupMembers] ([StoreGroupId], [StoreId]) VALUES (1, 1)
--INSERT [dbo].[StoreGroupMembers] ([StoreGroupId], [StoreId]) VALUES (1, 2)

--SET IDENTITY_INSERT [dbo].[RangeReviews] ON
--INSERT [dbo].[RangeReviews] ([Id], [CountryId], [TargetCurrencyId], [Title], [TotalMonths], [FirstMonth], [HasPriorYear], [ReportDate], [Bottom]) VALUES (1, 23, 5, N'Range Review 1', 12, CAST(0xC4320B00 AS Date), 1, CAST(0xB9330B00 AS Date), 5)
--INSERT [dbo].[RangeReviews] ([Id], [CountryId], [TargetCurrencyId], [Title], [TotalMonths], [FirstMonth], [HasPriorYear], [ReportDate], [Bottom]) VALUES (2, 4, 5, N'COLOMBIA I', 5, CAST(0xB9330B00 AS Date), 1, CAST(0xB9330B00 AS Date), 5)
--SET IDENTITY_INSERT [dbo].[RangeReviews] OFF

--SET IDENTITY_INSERT [dbo].[RangeReviewStores] ON
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (1, 1, 1, 1, 0, 1, 1)
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (2, 1, 2, 0, 0, 1, 1)
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (3, 1, 3, 0, 0, 1, 1)
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (4, 1, 4, 0, 0, 1, 1)
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (5, 1, 5, 0, 0, 1, 1)
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (6, 1, 6, 0, 0, 1, 1)
--INSERT [dbo].[RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration]) VALUES (7, 1, 7, 0, 0, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (8, 2, 56, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (9, 2, 57, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (10, 2, 58, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (11, 2, 59, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (12, 2, 60, 1, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (13, 2, 61, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (14, 2, 62, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (15, 2, 63, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (16, 2, 64, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (17, 2, 65, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (18, 2, 66, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (19, 2, 67, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (20, 2, 68, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (21, 2, 69, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (22, 2, 70, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (23, 2, 71, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (24, 2, 72, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (25, 2, 73, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (26, 2, 74, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (27, 2, 75, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (28, 2, 76, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (29, 2, 77, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (30, 2, 78, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (31, 2, 79, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (32, 2, 80, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (33, 2, 81, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (34, 2, 82, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (35, 2, 83, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (36, 2, 84, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (37, 2, 85, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (38, 2, 86, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (39, 2, 87, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (40, 2, 88, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (41, 2, 89, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (42, 2, 90, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (43, 2, 91, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (44, 2, 92, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (45, 2, 93, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (46, 2, 94, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (47, 2, 95, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (48, 2, 96, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (49, 2, 97, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (50, 2, 98, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (51, 2, 99, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (52, 2, 100, 0, 0, 1, 1, 1)
--INSERT [RangeReviewStores] ([Id], [RangeReviewId], [StoreId], [IsSameStore], [IsExcluded], [SKUCoverage], [SKUPenetration], [UseToCreateArticleMaster]) VALUES (53, 2, 101, 0, 0, 1, 1, 1)
--SET IDENTITY_INSERT [dbo].[RangeReviewStores] OFF

--SET IDENTITY_INSERT [dbo].[RangeReviewBenchmarks] ON
--INSERT [dbo].[RangeReviewBenchmarks] ([Id], [RangeReviewSourceId], [RangeReviewTargetId], [StoreId], [StoreGroupId], [TargetCurrencyId], [ColumnNumber]) VALUES (1, 1, NULL, 1, NULL, 5, 1)
--INSERT [dbo].[RangeReviewBenchmarks] ([Id], [RangeReviewSourceId], [RangeReviewTargetId], [StoreId], [StoreGroupId], [TargetCurrencyId], [ColumnNumber]) VALUES (2, 1, NULL, NULL, 1, 5, 1)
--SET IDENTITY_INSERT [dbo].[RangeReviewBenchmarks] OFF

--INSERT INTO RangeReviewSetup (RangeReviewId, CategoryId, Sales, SKUs, Units, Margin, Inventory, Space, Brand, Manufacturer, Subcategory, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)
--Select 1, Id, 1 Sales,1 SKUs ,1 Units,1 Margin,0 Inventory,0 Space,1 Brand ,1 Manufacturer, 1 Subcategory, 0 Attribute1, 0 Attribute2, 0 Attribute3, 0 Attribute4, 0 Attribute5 From Categories Where Level = 2

SET IDENTITY_INSERT [dbo].[Comments] ON
INSERT [dbo].[Comments] ([Id], [Type], [Description]) VALUES (1, 'Articles', 'Due to poor sales performance. Replacement will not create a gap in the range')
INSERT [dbo].[Comments] ([Id], [Type], [Description]) VALUES (2, 'Articles', 'SKU should be kept to maintain brand/size/segment presence')
INSERT [dbo].[Comments] ([Id], [Type], [Description]) VALUES (3, 'Articles', 'SKU has low store coverage')
INSERT [dbo].[Comments] ([Id], [Type], [Description]) VALUES (4, 'Articles', 'The SKU was recently introduced')
SET IDENTITY_INSERT [dbo].[Comments] OFF

--SET IDENTITY_INSERT [dbo].[UnitOfMeasureConvertions] ON
--INSERT [dbo].[UnitOfMeasureConvertions] ([Id], [SourceUnit], [TargetUnit], [Value]) VALUES (1, 'UN', 'PC', 20)
--SET IDENTITY_INSERT [dbo].[UnitOfMeasureConvertions] OFF


Delete From Comments
DBCC CheckIDENT(Comments, 'RESEED', 0)

INSERT INTO COMMENTS (Type, Description)
VALUES 
('Articles', 'Acceptable product turns'),
('Articles', 'SKU should be kept to maintain brand/size/segment presence'),
('Articles', 'The SKU was recently introduced'),
('Articles', 'SKU has low store coverage'),
('Articles', 'SKU should be kept since it presents positive evolution vs. PY.'),
('Articles', 'Inconsistent SKU(s) sales (manufacturer product outage, etc.).'),
('Articles', 'SKU creates sales and margin cannibalization (too many "like" Products in the range)'),
('Articles', 'The SKU was already de-listed'),
('Articles', 'Due to poor sales performance. Replacement will not create a gap in the range.')

GO